I want to write a function for comparing comma separated values that will take two values (comma separated values) after comparison the return value will be true or false
What changes I have to do in this SQL function ?
This function is given below:-
I am trying to write a function to compare comma separated values in SQL I've taken some code from Internet :
SELECT CASE WHEN EXISTS
(
SELECT 1 FROM dbo.Split(@v1)
WHERE ', ' + LTRIM(@v2) + ','
LIKE '%, ' + LTRIM(Item) + ',%'
) THEN 1 ELSE 0 END;
Then I make a function :
CREATE FUNCTION [dbo].[fnCompareCSVString]
(
@str1 nvarchar(50),
@str2 nvarchar(50)
)
RETURNS int
AS
BEGIN
SELECT CASE WHEN EXISTS
(
SELECT 1 FROM dbo.Split(@str1)
WHERE ', ' + LTRIM(@str2) + ','
LIKE '%, ' + LTRIM(Item) + ',%'
) THEN 1 ELSE 0 END;
END
I am not good in SQL I know this is wrong
Thanks in advance
shreesh chandra shukla
17-Jul-2013Is this what you are looking for?
True / False results
Returns
Only true matches
Returns
Item
val3
Split function